CREATE     PROCEDURE [dbo].[asi_PrcQueryProductPriceBreaks]
    @priceSheetVersionKey uniqueidentifier,
    @productKey uniqueidentifier,
    @currencyCode nchar(3)
    AS
BEGIN
    SELECT pvd.IsVersionOwner, pd.PriceDetailKey, pb.PriceBreakKey, pb.UomKey,
        Uom.Name UOM, pb.MinQuantity, pbr.PriceBasisDesc, pbr.PriceBasisCode, pb.IsPercent,
        pb.UnitRate
    FROM PriceVersionDetail pvd
    INNER JOIN PriceDetail pd ON pvd.PriceDetailKey = pd.PriceDetailKey
    INNER JOIN PriceBreak pb ON pd.PriceDetailKey = pb.PriceDetailKey
    INNER JOIN Uom ON pb.UomKey = Uom.UomKey
    INNER JOIN PriceBasisRef pbr ON pb.PriceBasisCode = pbr.PriceBasisCode
    WHERE pvd.PriceSheetVersionKey = @priceSheetVersionKey
    AND pd.ProductKey = @productKey
    AND pd.CurrencyCode = @currencyCode
    ORDER BY Uom.Name, pb.MinQuantity
END

GO